[dbo].[Exhb_Upsell]

Property	Value
Created	3:12:21 PM Friday, January 07, 2011
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

3:12:21 PM Friday, January 07, 2011

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Key iExhb_UpsellID: MEET_ID\PRODUCT_CODE$	MEET_ID	varchar(10)	10
$Cluster Key iExhb_UpsellID: MEET_ID\PRODUCT_CODE$	PRODUCT_CODE	varchar(31)	31
	UPSELL_PROD	varchar(31)	31
	NOTES	text	max
	TIME_STAMP	timestamp	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key iExhb_UpsellID: MEET_ID\PRODUCT_CODE$

MEET_ID

varchar(10)

$Cluster Key iExhb_UpsellID: MEET_ID\PRODUCT_CODE$

PRODUCT_CODE

varchar(31)

UPSELL_PROD

varchar(31)

NOTES

text

max

TIME_STAMP

timestamp

	Name	Columns
$Cluster Key iExhb_UpsellID: MEET_ID\PRODUCT_CODE$	iExhb_UpsellID	MEET_ID, PRODUCT_CODE

Name

Columns

$Cluster Key iExhb_UpsellID: MEET_ID\PRODUCT_CODE$

iExhb_UpsellID

MEET_ID, PRODUCT_CODE

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

Type

Action

Owning Principal

Grant

Delete

IMIS

Grant

Insert

IMIS

Grant

References

IMIS

Grant

Select

IMIS

Grant

Update

IMIS

SQL Script

CREATE TABLE [dbo].[Exhb_Upsell]
(
[MEET_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UPSELL_PROD] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [iExhb_UpsellID] ON [dbo].[Exhb_Upsell] ([MEET_ID], [PRODUCT_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Exhb_Upsell] TO [IMIS]
GRANT SELECT ON  [dbo].[Exhb_Upsell] TO [IMIS]
GRANT INSERT ON  [dbo].[Exhb_Upsell] TO [IMIS]
GRANT DELETE ON  [dbo].[Exhb_Upsell] TO [IMIS]
GRANT UPDATE ON  [dbo].[Exhb_Upsell] TO [IMIS]
GO